﻿-- =============================================
-- Author:		<Author,,Name>
-- Create date: <Create Date,,>
-- Description:	<Description,,>
-- =============================================
CREATE PROCEDURE [dbo].[usp_get_request_history]
AS
BEGIN
	-- SET NOCOUNT ON added to prevent extra result sets from
	-- interfering with SELECT statements.
	SET NOCOUNT ON;
    
	SELECT ID, Description, EndpointValue, BindingType, TransportType,
		TransportLocation, UDDIContactName, UDDIEmail, UDDIUserType,
		BiztalkApplication, EndpointName, Status, ModifiedBy, Category,
		TargetNamespace, MessageExchangePattern, JaxRPCResponse, 
		ServiceAction, CacheTimeOut, RequestAction, BusinessProvider, ServiceName, ModifiedDate
	FROM EndPoints
	ORDER by ModifiedDate Desc

END
